/*
CREATE TABLE "upc_template" (
  "sequence_nbr" TEXT NOT NULL,
  "qf_code" TEXT,
  "standard" TEXT,
  "sort" TEXT,
  "type" TEXT,
  "code" TEXT,
  "name" TEXT,
  "caculate_base" TEXT,
  "desc" TEXT,
  "rate" TEXT DEFAULT '',
  "type_code" TEXT,
  "remark" TEXT DEFAULT '',
  PRIMARY KEY ("sequence_nbr")
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct UpcTemplate {
    pub sequence_nbr: String,
    pub qf_code: Option<String>,
    pub standard: Option<String>,
    pub sort: String,
    pub r#type: Option<String>,
    pub code: Option<String>,
    pub name: Option<String>,
    pub caculate_base: Option<String>,
    pub desc: Option<String>,
    pub rate: Option<String>,
    pub type_code: Option<String>,
    pub remark: Option<String>,
}
crud!(UpcTemplate {}, "upc_template");
